Hi Bruno,
Thanks: my .tcshrc works with this...
setenv PATH "$PATH":/Library/MySQL/bin
setenv PATH "$PATH":/usr/local/bin
setenv PATH "$PATH":/usr/local/pgsql
setenv PATH "$PATH":/usr/local/pgsql/bin
...so now I get this response...
[MacGregor:/Users/roy] postgres% pg_ctl -D /usr/local/pgsql/data start
postmaster successfully started
[MacGregor:/Users/roy] postgres% LOG: database system was shut down
at 2003-11-22 12:06:33 GMT
LOG: checkpoint record is at 0/805FB4
LOG: redo record is at 0/805FB4; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 490; next oid: 16977
LOG: database system is ready
OK. Now I'm trying to get the PGDATA environment variable to work.
I've tried each the following lines in . tcshrc one at a time...
setenv PGDATA "$PGDATA":/usr/local/pgsql
setenv PGDATA "$PGDATA":/usr/local/pgsql/data
setenv PGDATA /usr/local/pgsql
setenv PGDATA /usr/local/pgsql/data
setenv $PGDATA /usr/local/pgsql
setenv $PGDATA /usr/local/pgsql/data
...and always get this response...
[MacGregor:/Users/roy] postgres% pg_ctl start
pg_ctl: no database directory or environment variable $PGDATA is specified
Try 'pg_ctl --help' for more information.
[MacGregor:/Users/roy] postgres%
...so what's going on?
regards,
Roy
--
--------------------
Roy MacGregor Paterson
MacGregorTech
t: +44 (0) 20 7584 7891
f: +44 (0) 20 7589 6223
m: +44 (0) 7803 163 938
w: www.macgregortech.com
e: roy@macgregortech.com
--------------------